﻿/****** Object:  Table [Core].[DBSchemaVer]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[DBSchemaVer] ([Name], [Version]) VALUES (N'Core', N'0.0.1     ')

/****** Object:  Table [Core].[Theme]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[Theme] ([ThemeId], [Name], [Layout], [Width], [ContentIdentifier], [SysMenuIdentifier], [MenuIdentifier]) VALUES (N'c06f5413-1d54-49ba-9f88-460663670155', N'Green Tea', N'~/Views/Shared/greentea/_Layout.cshtml', 960, N'content', N'sysmenu', N'menu')
INSERT [Core].[Theme] ([ThemeId], [Name], [Layout], [Width], [ContentIdentifier], [SysMenuIdentifier], [MenuIdentifier]) VALUES (N'b94cae6b-b0c0-48af-8125-49e8ccef7acc', N'Default', N'~/Views/Shared/_Layout.cshtml', 0, N'main', N'logindisplay', N'menucontainer')
INSERT [Core].[Theme] ([ThemeId], [Name], [Layout], [Width], [ContentIdentifier], [SysMenuIdentifier], [MenuIdentifier]) VALUES (N'b3132333-040a-4166-a383-dee4add249f4', N'Shallow Grunge', N'~/Views/Shared/shallowgrunge/_Layout.cshtml', 910, N'content', N'sysmenu', N'menu')

/****** Object:  Table [Core].[Role]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[Role] ([RoleId], [Name], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'322887bb-4b8f-4c42-ba6a-308e59d80b87', N'Anonymous User', N'N', CAST(0x00009E48010C92D6 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E48010C92D6 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Role] ([RoleId], [Name], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'ce0108b4-baa3-4388-a3a1-4f6ccbb5cc9f', N'Domain Administrator', N'N', CAST(0x00009E48010C2786 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E48010C2786 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Role] ([RoleId], [Name], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'546e5bf9-d289-4afc-98a1-77e7a19e9ff0', N'Client User', N'N', CAST(0x00009E48010C714E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E48010C714E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Role] ([RoleId], [Name], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'fd19a2ac-3e64-474e-aa00-b2c6318f86e1', N'BU Administrator', N'N', CAST(0x00009E48010C4F8B AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E48010C4F8B AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Role] ([RoleId], [Name], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'4bf418b2-a468-4a5a-a361-f832edc56db5', N'System Administrator', N'N', CAST(0x00009E48010BFAA4 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E48010BFAA4 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Deepak Chitnis')
UPDATE [Core].[Role] SET [CreateDT] = GETDATE(), [ModifiedDT] = GETDATE()

/****** Object:  Table [Core].[Plugin]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[Plugin] ([PluginId], [Name], [Version], [DBVersionRequired], [Area], [Controller], [Action], [UserPermission], [AdminController], [AdminAction], [AdminPermission], [IsDroppedYN]) VALUES (N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Core', N'0.0.1.0', N'0.0.1.31934', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'N')

/****** Object:  Table [Core].[Permission]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'a6a72f3e-5f71-4a9e-8e2d-0563230f20d4', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Administer User')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'486b2fdf-c5af-44a8-b237-1af870826be8', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Modify Domain')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'6d153d8a-355a-4e00-b59a-1bdca0aa9715', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Administer BU')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'6476b80a-60c5-4869-a3e7-252720c2b0f1', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Administer System Wide Tags')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'8e4b4d81-716e-4b0a-aaf8-3523f5f03c25', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Approve Documents')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'808f01a3-2169-4508-be36-86d092c67e9e', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Administer Tags')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'29d3d11a-5d6d-40f8-822b-8d12c54ea117', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Administer Files')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'16c62c55-9cb1-4c71-bee9-961b23af03c7', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Use Anonymously')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'a9e94864-fb1f-45da-833e-99a9e9357695', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can View Content')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'd8756c9c-0df3-4228-bc76-9ececb12bd7d', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Create/Delete Domain')
INSERT [Core].[Permission] ([PermissionId], [PluginId], [Name]) VALUES (N'd6406adf-66f3-47f6-bbad-f41b7f82e864', N'0bd94a04-6a06-4fa8-b9b2-7fec8db9b522', N'Can Contribute Documents')

/****** Object:  Table [Core].[RolePermission]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'a6a72f3e-5f71-4a9e-8e2d-0563230f20d4', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'486b2fdf-c5af-44a8-b237-1af870826be8', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'6d153d8a-355a-4e00-b59a-1bdca0aa9715', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'6476b80a-60c5-4869-a3e7-252720c2b0f1', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'8e4b4d81-716e-4b0a-aaf8-3523f5f03c25', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'808f01a3-2169-4508-be36-86d092c67e9e', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'29d3d11a-5d6d-40f8-822b-8d12c54ea117', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'a9e94864-fb1f-45da-833e-99a9e9357695', N'322887bb-4b8f-4c42-ba6a-308e59d80b87')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'a9e94864-fb1f-45da-833e-99a9e9357695', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'd8756c9c-0df3-4228-bc76-9ececb12bd7d', N'4bf418b2-a468-4a5a-a361-f832edc56db5')
INSERT [Core].[RolePermission] ([PermissionId], [RoleId]) VALUES (N'd6406adf-66f3-47f6-bbad-f41b7f82e864', N'4bf418b2-a468-4a5a-a361-f832edc56db5')

/****** Object:  Table [Core].[TagCategory]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[TagCategory] ([TagCategoryId], [BusinessUnitId], [TagCategoryName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'f9834140-6355-406b-94a9-22e6885e4211', NULL, N'Address Type', N'N', CAST(0x00009E61011D8CDA AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011D8CDA AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[TagCategory] ([TagCategoryId], [BusinessUnitId], [TagCategoryName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'63d9513f-7a37-4e2d-8827-f0f6e77f1bbf', NULL, N'File', N'N', CAST(0x00009E5A00C4A539 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E5A00C4A539 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[TagCategory] ([TagCategoryId], [BusinessUnitId], [TagCategoryName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'5452c87f-2cc7-48b8-a320-f8c5859697b4', NULL, N'Company Type', N'N', CAST(0x00009E4600D0621E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E4600D0621E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
UPDATE [Core].[TagCategory] SET [CreateDT] = GETDATE(), [ModifiedDT] = GETDATE()

/****** Object:  Table [Core].[Tag]    Script Date: 02/16/2011 14:48:44 ******/
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'f2f29aa0-6369-4ec4-8c48-0248b904f5e2', NULL, N'f9834140-6355-406b-94a9-22e6885e4211', N'Billing Address', N'N', CAST(0x00009E61011DAE6F AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011DAE6F AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'77085ab6-580b-4080-831a-127d78120512', NULL, N'5452c87f-2cc7-48b8-a320-f8c5859697b4', N'Vendor', N'N', CAST(0x00009E46011271EE AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E46011271EE AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'12e2c8a6-12d4-4ce1-9f42-14af9b577639', NULL, N'f9834140-6355-406b-94a9-22e6885e4211', N'Main Address', N'N', CAST(0x00009E61011D9F27 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011D9F27 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'4e6927ae-b814-4ae8-a39f-6abbcce83b69', NULL, N'63d9513f-7a37-4e2d-8827-f0f6e77f1bbf', N'Documents', N'N', CAST(0x00009E5A00C4C6FA AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E5A00C4C6FA AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'3d6c4f39-f34e-4438-b754-706e72ef18de', NULL, N'63d9513f-7a37-4e2d-8827-f0f6e77f1bbf', N'Screen Shots', N'N', CAST(0x00009E5A00C4DA8F AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E5A00C4DA8F AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'f3042def-5b8d-443e-a6de-9643762921d5', NULL, N'f9834140-6355-406b-94a9-22e6885e4211', N'Home', N'N', CAST(0x00009E61011DC30E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011DC30E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'34330895-aefd-4be8-9d02-a0ca0ad35a61', NULL, N'5452c87f-2cc7-48b8-a320-f8c5859697b4', N'Customer', N'N', CAST(0x00009E46011268AC AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E46011268AC AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'e5f2daa0-93ab-4efb-b8dd-f1af69c25892', NULL, N'63d9513f-7a37-4e2d-8827-f0f6e77f1bbf', N'Images', N'N', CAST(0x00009E5A00C4BB3E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E5A00C4BB3E AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'e6c2af70-f166-4089-a049-fa80c481439b', NULL, N'f9834140-6355-406b-94a9-22e6885e4211', N'Work', N'N', CAST(0x00009E61011DCB5C AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011DCB5C AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
INSERT [Core].[Tag] ([TagId], [BusinessUnitId], [TagCategoryId], [TagName], [IsDroppedYN], [CreateDT], [CreatedById], [CreatedByName], [ModifiedDT], [ModifiedById], [ModifiedByName]) VALUES (N'4d5097b6-88eb-42ae-af59-fc9bd8cce6a2', NULL, N'f9834140-6355-406b-94a9-22e6885e4211', N'Shipping Address', N'N', CAST(0x00009E61011DB976 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup', CAST(0x00009E61011DB976 AS DateTime), N'00000000-0000-0000-0000-000000000000', N'Initial Setup')
UPDATE [Core].[Tag] SET [CreateDT] = GETDATE(), [ModifiedDT] = GETDATE()
